In [1]:

Columns description

  1. url contains the url of the restaurant in the zomato website

  2. address contains the address of the restaurant in Bengaluru

  3. name contains the name of the restaurant

  4. online_order whether online ordering is available in the restaurant or not

  5. book_table table book option available or not

  6. rate contains the overall rating of the restaurant out of 5

  7. votes contains total number of rating for the restaurant as of the above mentioned date

  8. phone contains the phone number of the restaurant

  9. location contains the neighborhood in which the restaurant is located

  10. rest_type restaurant type

  11. dish_liked dishes people liked in the restaurant

  12. cuisines food styles, separated by comma

  13. approx_cost(for two people) contains the approximate cost for meal for two people

  14. reviews_list list of tuples containing reviews for the restaurant, each tuple

  15. menu_item contains list of menus available in the restaurant

  16. listed_in(type) type of meal

  17. listed_in(city) contains the neighborhood in which the restaurant is listed

In [2]:
Out[2]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1/5 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1/5 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8/5 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7/5 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8/5 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari
In [3]:
Out[3]:
(51717, 17)
In [4]:
Out[4]:
url                            object
address                        object
name                           object
online_order                   object
book_table                     object
rate                           object
votes                           int64
phone                          object
location                       object
rest_type                      object
dish_liked                     object
cuisines                       object
approx_cost(for two people)    object
reviews_list                   object
menu_item                      object
listed_in(type)                object
listed_in(city)                object
dtype: object
In [5]:
Out[5]:
8792
In [6]:
Out[6]:
url                                0
address                            0
name                               0
online_order                       0
book_table                         0
rate                            7775
votes                              0
phone                           1208
location                          21
rest_type                        227
dish_liked                     28078
cuisines                          45
approx_cost(for two people)      346
reviews_list                       0
menu_item                          0
listed_in(type)                    0
listed_in(city)                    0
dtype: int64

getting all NAN features

In [7]:
Out[7]:
['rate',
 'phone',
 'location',
 'rest_type',
 'dish_liked',
 'cuisines',
 'approx_cost(for two people)']
In [8]:
rate has 15.0337 % missing values
phone has 2.3358 % missing values
location has 0.0406 % missing values
rest_type has 0.4389 % missing values
dish_liked has 54.2916 % missing values
cuisines has 0.087 % missing values
approx_cost(for two people) has 0.669 % missing values
In [9]:
Out[9]:
array(['4.1/5', '3.8/5', '3.7/5', '3.6/5', '4.6/5', '4.0/5', '4.2/5',
       '3.9/5', '3.1/5', '3.0/5', '3.2/5', '3.3/5', '2.8/5', '4.4/5',
       '4.3/5', 'NEW', '2.9/5', '3.5/5', nan, '2.6/5', '3.8 /5', '3.4/5',
       '4.5/5', '2.5/5', '2.7/5', '4.7/5', '2.4/5', '2.2/5', '2.3/5',
       '3.4 /5', '-', '3.6 /5', '4.8/5', '3.9 /5', '4.2 /5', '4.0 /5',
       '4.1 /5', '3.7 /5', '3.1 /5', '2.9 /5', '3.3 /5', '2.8 /5',
       '3.5 /5', '2.7 /5', '2.5 /5', '3.2 /5', '2.6 /5', '4.5 /5',
       '4.3 /5', '4.4 /5', '4.9/5', '2.1/5', '2.0/5', '1.8/5', '4.6 /5',
       '4.9 /5', '3.0 /5', '4.8 /5', '2.3 /5', '4.7 /5', '2.4 /5',
       '2.1 /5', '2.2 /5', '2.0 /5', '1.8 /5'], dtype=object)
In [10]:
In [11]:
Out[11]:
(43942, 17)
In [12]:
In [13]:
In [14]:
Out[14]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari
In [15]:
Out[15]:
array(['4.1', '3.8', '3.7', '3.6', '4.6', '4.0', '4.2', '3.9', '3.1',
       '3.0', '3.2', '3.3', '2.8', '4.4', '4.3', 'NEW', '2.9', '3.5',
       '2.6', '3.8 ', '3.4', '4.5', '2.5', '2.7', '4.7', '2.4', '2.2',
       '2.3', '3.4 ', '-', '3.6 ', '4.8', '3.9 ', '4.2 ', '4.0 ', '4.1 ',
       '3.7 ', '3.1 ', '2.9 ', '3.3 ', '2.8 ', '3.5 ', '2.7 ', '2.5 ',
       '3.2 ', '2.6 ', '4.5 ', '4.3 ', '4.4 ', '4.9', '2.1', '2.0', '1.8',
       '4.6 ', '4.9 ', '3.0 ', '4.8 ', '2.3 ', '4.7 ', '2.4 ', '2.1 ',
       '2.2 ', '2.0 ', '1.8 '], dtype=object)
In [16]:
In [17]:
In [18]:

calculate avg rating of each resturant

In [19]:
Out[19]:
<AxesSubplot:xlabel='name'>
In [20]:
Out[20]:
restaurant rating
0 #FeelTheROLL 3.400000
1 #L-81 Cafe 3.900000
2 #refuel 3.700000
3 1000 B.C 3.200000
4 100°C 3.700000
5 11 to 11 Express Biriyanis 3.500000
6 1131 Bar + Kitchen 4.500000
7 12th Main - Grand Mercure 4.100000
8 1441 Pizzeria 4.100000
9 1522 - The Pub 4.212000
10 154 Breakfast Club 4.000000
11 1722 Urban Bistro 4.100000
12 18+ Ice Cafe 3.500000
13 1947 4.021429
14 1980s Games Cafe 3.400000
15 1992 Chats - Space 3.700000
16 1Q1 4.300000
17 1TO3 Kitchen 3.100000
18 2 Statez 3.700000
19 20 Char - Sterlings MAC Hotel 4.000000
In [21]:
Out[21]:
(7162, 2)

alternative is create a list in which u have all the restaurants & in another list,we have all ratings & then using zip we can create a dataframe

In [ ]:
In [ ]:
In [ ]:
Rating distribution
In [22]:
Out[22]:
<AxesSubplot:xlabel='rating', ylabel='Density'>
Almost more than 50 percent of restaurants has rating between 3 and 4. Restaurants having rating more than 4.5 are very rare.
In [ ]:

Which are the top restaurant chains in Bangaluru?

In [23]:
Out[23]:
Text(0.5, 0, 'Number of outlets')
In [ ]:
How many of the restuarants do not accept online orders?
In [24]:
Out[24]:
([<matplotlib.patches.Wedge at 0x1f11031dcd0>,
  <matplotlib.patches.Wedge at 0x1f11032c400>],
 [Text(-0.481488774517003, 0.9890240442042423, ''),
  Text(0.5252605823084886, -1.0789352717716423, '')],
 [Text(-0.26263024064563795, 0.5394676604750411, '64.4%'),
  Text(0.30640200634661835, -0.629378908533458, '35.6%')])
using plotly, How many of the restuarants do not accept online orders?
In [25]:
Requirement already satisfied: plotly in c:\users\cmraj\anaconda3\lib\site-packages (5.1.0)
Requirement already satisfied: six in c:\users\cmraj\anaconda3\lib\site-packages (from plotly) (1.15.0)
Requirement already satisfied: tenacity>=6.2.0 in c:\users\cmraj\anaconda3\lib\site-packages (from plotly) (8.0.1)
In [26]:
In [27]:
In [28]:
In [ ]:

What is the ratio b/w restaurants that provide and do not provide table booking ?

In [29]:
Out[29]:
([<matplotlib.patches.Wedge at 0x1f111156670>,
  <matplotlib.patches.Wedge at 0x1f111156d60>],
 [Text(-0.9856961240827233, 0.4882654513359477, ''),
  Text(1.0753048626356982, -0.5326532196392153, '')],
 [Text(-0.537652431317849, 0.26632660981960776, '85.4%'),
  Text(0.6272611698708239, -0.31071437812287556, '14.6%')])
using plotly, #### What is the ratio b/w restaurants that provide and do not provide table booking ?
In [30]:
In [31]:
In [32]:
In [33]:
In [ ]:
In [ ]:
In [ ]:

How many types of restaurants we have?

In [34]:
Out[34]:
151
In [35]:
In [36]:
Out[36]:
151
In [37]:
Out[37]:
88

How many types of restaurants we have?

In [38]:
using plotly, How many types of restaurant do we have
In [39]:
In [40]:
Quick BitesCasual DiningCafeDessert ParlorDeliveryTakeaway, DeliveryCasual Dining, BarBakeryBeverage ShopBarFood CourtBar, Casual DiningLoungePubSweet ShopFine DiningCasual Dining, CafePub, Casual DiningBeverage Shop, Quick BitesBakery, Quick Bites02k4k6k8k10k12k14k
In [ ]:
At all, Banglore is known as the tech capital of India,people having busy and modern life will prefer Quick Bites.
We can observe tha Quick Bites type restaurants dominates.
In [ ]:

highest voted restaurant

In [41]:
Out[41]:
<AxesSubplot:xlabel='name'>
using plotly highest voted restaurants
In [42]:
In [43]:
Byg Brewski Brewing CompanyToitTrufflesAB's - Absolute BarbecuesThe Black PearlBig PitcherOnestaArbor Brewing CompanyEmpire RestaurantProst Brew Pub05k10k15k
In [ ]:

total restaurants at different locations of Bengalore

In [44]:
Out[44]:
location
BTM                  [Sankranthi Veg Restaurant, Hearts Unlock Cafe...
Banashankari         [Jalsa, Spice Elephant, San Churro Cafe, Addhu...
Banaswadi            [Cafe Nibras, The Sanctuary, Crunch Pizzas, Pi...
Bannerghatta Road    [Deja Vu Resto Bar, Fattoush, Empire Restauran...
Basavanagudi         [Grand Village, Timepass Dinner, Srinathji's C...
                                           ...                        
West Bangalore       [FreshMenu, Fit Dish Fetish, Garden City Mobil...
Whitefield           [Imperio Cafe, Night Diaries, LocalHost, AB's ...
Wilson Garden        [Tree Top, Sahana's (Nati Style), Karavali Kol...
Yelahanka            [Prashanth Naati Corner, Cheta's Kitchen, Twis...
Yeshwantpur          [Chef's Bank, New Agarwal Bhavan, Fishing Boat...
Name: name, Length: 92, dtype: object
In [45]:
In [46]:
Out[46]:
restaurant
location
Bellandur 284
Jayanagar 311
Bannerghatta Road 362
JP Nagar 400
Indiranagar 467
Electronic City 518
Marathahalli 525
HSR 553
BTM 581
Whitefield 634
In [47]:
Out[47]:
<AxesSubplot:xlabel='location'>
In [48]:
Out[48]:
Index(['Bellandur', 'Jayanagar', 'Bannerghatta Road', 'JP Nagar',
       'Indiranagar', 'Electronic City', 'Marathahalli', 'HSR', 'BTM',
       'Whitefield'],
      dtype='object', name='location')
In [49]:
In [50]:
WhitefieldBTMHSRMarathahalliElectronic CityIndiranagarJP NagarBannerghatta RoadJayanagarBellandur0100200300400500600
In [51]:
Out[51]:
url                                0
address                            0
name                               0
online_order                       0
book_table                         0
rate                               0
votes                              0
phone                            832
location                           0
rest_type                        151
dish_liked                     20333
cuisines                          11
approx_cost(for two people)      252
reviews_list                       0
menu_item                          0
listed_in(type)                    0
listed_in(city)                    0
dtype: int64

different type of restaurants

In [52]:
Out[52]:
Quick Bites                   34.302035
Casual Dining                 22.582040
Cafe                           8.026489
Dessert Parlor                 4.412635
Delivery                       4.075827
                                ...    
Dessert Parlor, Food Court     0.004551
Dessert Parlor, Kiosk          0.004551
Bakery, Food Court             0.004551
Cafe, Food Court               0.004551
Quick Bites, Kiosk             0.002276
Name: rest_type, Length: 87, dtype: float64

Total number of variety of restaurants ie north indian,south Indian

In [53]:
Out[53]:
Text(0.5, 1.0, 'Most popular cuisines of Bangalore')
In [54]:
In [55]:
North IndianNorth Indian, ChineseSouth IndianCafeBakery, DessertsBiryaniSouth Indian, North Indian, ChineseFast FoodDessertsChinese0500100015002000

We can observe that North Indian,chinese,South Indian and Biriyani are most common.

It means Bengalore is more influenced by North Indian culture more than South

In [ ]:

Analyse Approx cost for 2 people

In [56]:
Out[56]:
66
In [57]:
Out[57]:
252
In [58]:
In [59]:
Out[59]:
0
In [60]:
Out[60]:
array(['800', '300', '600', '700', '550', '500', '450', '650', '400',
       '900', '200', '750', '150', '850', '100', '1,200', '350', '250',
       '950', '1,000', '1,500', '1,300', '199', '80', '1,100', '160',
       '1,600', '230', '130', '1,700', '1,400', '1,350', '2,200', '2,000',
       '1,800', '1,900', '180', '330', '2,500', '2,100', '3,000', '2,800',
       '3,400', '50', '40', '1,250', '3,500', '4,000', '2,400', '2,600',
       '1,450', '70', '3,200', '560', '240', '360', '6,000', '1,050',
       '2,300', '4,100', '120', '5,000', '3,700', '1,650', '2,700',
       '4,500'], dtype=object)
In [61]:
In [62]:
Out[62]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
67 https://www.zomato.com/gustoesbeerhouse?contex... 10, 30th Main, Deve Gowda Petrol Bunk Road, 3r... Gustoes Beer House No No 4.1 868 080 49653521 Banashankari Pub Beer, Wedges, Pizza, Nachos, Salads, Papaya Sa... Continental, Italian, Mexican, North Indian, C... 1,200 [('Rated 5.0', 'RATED\n Has a really calm roo... [] Delivery Banashankari
119 https://www.zomato.com/bangalore/k27-the-pub-b... 27, 27th Cross, 2nd Stage, Banashankari, Banga... K27 - The Pub No No 3.1 30 +91 9980097472 Banashankari Bar NaN Chinese, North Indian 1,000 [('Rated 4.0', "RATED\n Convenient and Averag... [] Delivery Banashankari
166 https://www.zomato.com/bangalore/patio-805-jay... 805, Ground Floor, 35C Cross, 9th Main, 4th Bl... Patio 805 Yes Yes 4.1 364 +91 8884999805 Jayanagar Casual Dining Noodles, Laksa Soup, Coffee, Veg Fritters, Veg... Thai, Vietnamese, Asian, Chinese 1,200 [('Rated 4.0', "RATED\n The number of good re... [] Delivery Banashankari
207 https://www.zomato.com/bangalore/chutney-chang... Cosmopolitan Club, 22nd Cross, 3rd Block, Jaya... Chutney Chang Yes Yes 4.1 2339 080 22443007\r\n+91 9901967373 Jayanagar Casual Dining Veg Momos, Brownie Chocolate, Palak Chaat, Mut... North Indian, Chinese, BBQ 1,500 [('Rated 4.0', 'RATED\n Great place for team ... [] Delivery Banashankari
217 https://www.zomato.com/bangalore/toscano-jayan... 359/38,Next to Fabindia, 7th Cross, 1st Block,... Toscano Yes Yes 4.3 1129 080 41558423\r\n+91 7619320074 Jayanagar Casual Dining Pizza, Pasta, Salads, Calamari, Ravioli, Pumpk... Italian, Salad 1,300 [('Rated 4.0', 'RATED\n Saturday Night Dinner... [] Delivery Banashankari
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
51707 https://www.zomato.com/bangalore/m-bar-bengalu... Bengaluru Marriott Hotel, 75, 8th Road, EPIP A... M Bar - Bengaluru Marriott Hotel Whitefield No No 3.9 77 080 49435000 Whitefield Fine Dining, Bar Rooftop Ambience Finger Food 2,000 [('Rated 4.0', 'RATED\n Went there post dinne... [] Pubs and bars Whitefield
51708 https://www.zomato.com/bangalore/keys-cafe-key... Keys Hotel, 6, 1st Phase Industrial Area, Near... Keys Cafe - Keys Hotel No No 2.8 161 080 39451000\n+91 8884038484 Whitefield Casual Dining, Bar Salads, Coffee, Breakfast Buffet, Halwa, Chick... Chinese, Continental, North Indian 1,200 [('Rated 3.0', 'RATED\n Place is good not tha... [] Pubs and bars Whitefield
51712 https://www.zomato.com/bangalore/best-brews-fo... Four Points by Sheraton Bengaluru, 43/3, White... Best Brews - Four Points by Sheraton Bengaluru... No No 3.6 27 080 40301477 Whitefield Bar NaN Continental 1,500 [('Rated 5.0', "RATED\n Food and service are ... [] Pubs and bars Whitefield
51715 https://www.zomato.com/bangalore/chime-sherato... Sheraton Grand Bengaluru Whitefield Hotel & Co... Chime - Sheraton Grand Bengaluru Whitefield Ho... No Yes 4.3 236 080 49652769 ITPL Main Road, Whitefield Bar Cocktails, Pizza, Buttermilk Finger Food 2,500 [('Rated 4.0', 'RATED\n Nice and friendly pla... [] Pubs and bars Whitefield
51716 https://www.zomato.com/bangalore/the-nest-the-... ITPL Main Road, KIADB Export Promotion Industr... The Nest - The Den Bengaluru No No 3.4 13 +91 8071117272 ITPL Main Road, Whitefield Bar, Casual Dining NaN Finger Food, North Indian, Continental 1,500 [('Rated 5.0', 'RATED\n Great ambience , look... [] Pubs and bars Whitefield

6798 rows × 17 columns

In [63]:
Out[63]:
dtype('O')
In [64]:
Out[64]:
0          800
1          800
2          800
3          300
4          600
         ...  
51709      800
51711      800
51712    1,500
51715    2,500
51716    1,500
Name: approx_cost(for two people), Length: 43690, dtype: object
In [65]:
Out[65]:
str

remove ,

In [66]:
In [67]:
In [ ]:
cost vs rating
In [68]:
from this scattterplot,we can come up with a conclusion ya most of the highest rated accepts online order and they r budgeted too
In [ ]:
In [69]:
Out[69]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari
In [ ]:

Is there any difference b/w votes of restaurants accepting and not accepting online orders?

In [70]:
Out[70]:
<AxesSubplot:xlabel='online_order', ylabel='votes'>

from this boxplot,we can observe that median number of votes for both categories vary.

Restaurants accepting online orders get more votes from customers as there is a rating option poping up after each order through zomato application.

In [ ]:
In [ ]:

Is there any difference b/w price of restaurants accepting and not accepting online orders?

In [71]:
Out[71]:
<AxesSubplot:xlabel='online_order', ylabel='approx_cost(for two people)'>
In [72]:
YesNo0100020003000400050006000
online_orderapprox_cost(for two people)

Restaurants accepting online orders are more affordable than Restaurants who are accepting online orders

In [ ]:
In [ ]:

Cheapest Rate for 2 people

In [73]:
Out[73]:
40

Most costly for 2 people

In [74]:
Out[74]:
6000
In [75]:
Out[75]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
19139 https://www.zomato.com/bangalore/le-cirque-sig... The Leela Palace, 23, Old Airport Road, Bangalore Le Cirque Signature - The Leela Palace No Yes 4.3 126 080 30571234\r\n080 30571540 Old Airport Road Fine Dining Wine, Asparagus Soup, Creme Brulee, Pasta, Rav... French, Italian 6000 [('Rated 5.0', 'RATED\n Awesome would be an u... [] Dine-out Indiranagar
45618 https://www.zomato.com/bangalore/le-cirque-sig... The Leela Palace, 23, Old Airport Road, Bangalore Le Cirque Signature - The Leela Palace No Yes 4.3 128 080 30571234\n080 30571540 Old Airport Road Fine Dining Wine, Asparagus Soup, Creme Brulee, Pasta, Rav... French, Italian 6000 [('Rated 5.0', 'RATED\n Awesome would be an u... [] Dine-out Old Airport Road
In [76]:
Out[76]:
19139    Le Cirque Signature - The Leela Palace
45618    Le Cirque Signature - The Leela Palace
Name: name, dtype: object
In [ ]:
distribution of cost for 2 people
In [77]:
In [78]:
1000200030004000500060000100020003000400050006000
approx_cost(for two people)count
most of the price lies between in a range of under 1000,it means most are affordable & very few are luxurious
In [ ]:

Most costly Rate for 2 people is served at which Restaurant what exactly is the dish involved in this and liked dish of that restaurant

In [79]:
Out[79]:
name cuisines dish_liked
19139 Le Cirque Signature - The Leela Palace French, Italian Wine, Asparagus Soup, Creme Brulee, Pasta, Rav...
45618 Le Cirque Signature - The Leela Palace French, Italian Wine, Asparagus Soup, Creme Brulee, Pasta, Rav...
In [80]:
Out[80]:
name cuisines dish_liked
19139 Le Cirque Signature - The Leela Palace French, Italian Wine, Asparagus Soup, Creme Brulee, Pasta, Rav...
45618 Le Cirque Signature - The Leela Palace French, Italian Wine, Asparagus Soup, Creme Brulee, Pasta, Rav...
In [81]:
In [82]:
Out[82]:
url                             object
address                         object
name                            object
online_order                    object
book_table                      object
rate                           float64
votes                            int64
phone                           object
location                        object
rest_type                       object
dish_liked                      object
cuisines                        object
approx_cost(for two people)      int32
reviews_list                    object
menu_item                       object
listed_in(type)                 object
listed_in(city)                 object
dtype: object
In [83]:
In [ ]:

Top 10 Most Expensive restaurant with approx cost for 2 people

In [84]:
Out[84]:
<AxesSubplot:xlabel='name'>
In [85]:
Le Cirque Signature - The Leela PalaceRoyal Afghan - ITC WindsorMalties - Radisson BluLa Brasserie - Le MeridienAlba - JW Marriott Bengaluru05k10k15k
In [ ]:

Top 10 Cheapest restaurant with approx cost for 2 people

In [86]:
Out[86]:
<AxesSubplot:xlabel='name'>
In [87]:
Srinidhi Sagar Food LineSrinidhi SagarSrinidhi Sagar DeluxeSavera Cafe020406080100120140160
In [ ]:

Top 10 Cheapest restaurant location wise with approx cost for 2 people

In [88]:
Out[88]:
location
Indiranagar         40
Indiranagar         40
Indiranagar         40
Old Airport Road    40
Indiranagar         40
Domlur              40
Domlur              40
Old Airport Road    40
Shivajinagar        50
Shivajinagar        50
Name: approx_cost(for two people), dtype: int32

all the restautant that are below than 500(budget hotel)

In [89]:
Out[89]:
url address online_order book_table rate votes phone rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
location
Banashankari https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... No No 3.7 88 +91 9620009302 Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
Banashankari https://www.zomato.com/bangalore/caf%C3%A9-dow... 12,29 Near PES University Back Gate, D'Souza N... Yes No 4.1 402 080 26724489\r\n+91 7406048982 Cafe Waffles, Pasta, Crispy Chicken, Honey Chilli C... Cafe 500 [('Rated 4.0', 'RATED\n We ended up here on a... [] Cafes Banashankari
Banashankari https://www.zomato.com/bangalore/the-coffee-sh... 6th Block, 3rd Stage, Banashankari, Bangalore Yes Yes 4.2 164 +91 9731644212 Cafe Coffee, Spaghetti, Pancakes, Nachos, Pasta, Sa... Cafe, Chinese, Continental, Italian 500 [('Rated 4.0', "RATED\n Food - 4/5\nAmbience ... [] Cafes Banashankari
Banashankari https://www.zomato.com/bangalore/caf-eleven-ba... 111, Sapphire Toys Building, 100 Feet Ring Roa... No No 4.0 424 080 49577715 Cafe Sandwich, Omelette, Ice Tea, Virgin Mojito, Ho... Cafe, Continental 450 [('Rated 2.0', "RATED\n This is a hookah cafe... [] Cafes Banashankari
Banashankari https://www.zomato.com/bangalore/t3h-cafe-bana... 504, CJ Venkata Das Road, Padmanabhangar, 2nd ... No No 3.9 93 +91 8884726600 Cafe Cheese Maggi, Peri Peri Fries, Pasta Arrabiata Cafe, Italian, American 300 [('Rated 4.0', "RATED\n Happy to see such a c... [] Cafes Banashankari
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Brookefield https://www.zomato.com/bangalore/venice-kerala... Opposite Brookfield Mall, Shiva Temple Road, B... No No 3.7 34 +91 8880059495 Quick Bites NaN Kerala 200 [('Rated 5.0', 'RATED\n Loved this restaurant... [] Dine-out Whitefield
KR Puram https://www.zomato.com/bangalore/thai-chinese-... 7, Anurhh Arcade, Hoodi Road, Kodigehalli Road... No No 3.4 7 +91 9206260085\n+91 7619416923 Quick Bites NaN Chinese, Thai 400 [('Rated 5.0', 'RATED\n Its Looking delicious... [] Dine-out Whitefield
Brookefield https://www.zomato.com/bangalore/the-crunch-br... 33/1, Kundalahalli Road, Brookefield, Bangalore No No 3.3 6 +91 9016277963 Beverage Shop NaN Beverages 300 [('Rated 3.0', 'RATED\n the sandwich was not ... [] Dine-out Whitefield
KR Puram https://www.zomato.com/bangalore/punjabi-charc... 7, Anurhh Arcade, Hoodi Road, Kodigehalli Road... No No 3.6 31 +91 9341341916\n+91 7619416499 Quick Bites NaN North Indian, Chinese 400 [('Rated 3.0', 'RATED\n A nice little place f... [] Dine-out Whitefield
Brookefield https://www.zomato.com/bangalore/raapchick-bro... Opposite Brookefield Mall, Kundanhalli, Brooke... Yes No 3.6 49 080 41717785\n+91 9571153004 Quick Bites Burgers Fast Food, Burger 300 [('Rated 5.0', "RATED\n I was randomly lookin... ['Chicken Wrap', 'Veg Crunch Burger', 'Spicy P... Dine-out Whitefield

26330 rows × 15 columns

In [90]:
Out[90]:
location approx_cost(for two people)
0 Banashankari 300
1 Banashankari 500
2 Banashankari 500
3 Banashankari 450
4 Banashankari 300
In [91]:
Out[91]:
<AxesSubplot:>

we can conclude that 300 and 400 cost dishes are maximum in count

In [92]:
In [ ]:

Restaurants that have better rating >4 and that are under budget too

In [93]:
Out[93]:
(4007, 17)

Total no. of Restaurants that have better rating >4 and that are under budget too ie less than 500

In [94]:
Out[94]:
628
In [ ]:

Total such various affordable hotels at different location

In [102]:
In [103]:
Out[103]:
68
In [104]:
Out[104]:
68
In [105]:
In [106]:
Out[106]:
restaurant
location
BTM 54
Banashankari 25
Banaswadi 3
Bannerghatta Road 19
Basavanagudi 31
Basaveshwara Nagar 3
Bellandur 20
Brigade Road 11
Brookefield 16
Church Street 8
City Market 1
Commercial Street 4
Cunningham Road 4
Domlur 5
Ejipura 1
Electronic City 23
Frazer Town 15
HBR Layout 3
HSR 58
Hebbal 1
In [107]:
Out[107]:
list
In [108]:
Out[108]:
Text(0, 0.5, 'Total restaurants')
In [109]:
HSRIndiranagarJayanagarBTMKoramangala 5th BlockMalleshwaramJP NagarWhitefieldMarathahalliBasavanagudi0102030405060
In [ ]:
In [ ]:

To Visualise what are the names of those hotels

In [110]:
In [111]:
Out[111]:
res_names
location
BTM [eat.fit, Hiyar Majhe Kolkata, XO Belgian Waff...
Banashankari [Café Down The ...
Banaswadi [Pooja Dosa Camp, Corner House Ice Cream, The ...
Bannerghatta Road [BOX8- Desi Meals, Krishna Kuteera, Krishna Ku...
Basavanagudi [Kabab Magic, Sri Guru Kottureshwara Davangere...
In [ ]:

Finding Best budget Restaurants in any location

we will pass location and restaurant type as parameteres,function will return name of restaurants.
In [112]:
In [113]:
Out[113]:
array(['Swadista Aahar', 'Litti Twist', 'The Shawarma Shop', 'Gorbandh',
       'Yum In My Tum', 'Chaatimes', "Muthashy's", 'Swad Punjab Da',
       "Domino's Pizza", 'Roti Wala', 'Andhra Kitchen'], dtype=object)
In [ ]:

Which are the foodie areas?

In [114]:
Out[114]:
<AxesSubplot:xlabel='location'>
In [115]:
BTMKoramangala 5th BlockHSRIndiranagarJP NagarJayanagarWhitefieldMarathahalliBannerghatta RoadKoramangala 6th BlockKoramangala 7th BlockBrigade RoadBellandurKoramangala 1st BlockElectronic CitySarjapur RoadUlsoorKoramangala 4th BlockMG RoadBanashankari05001000150020002500300035004000

We can see that BTM,HSR and Koranmangala 5th block has the most number of restaurants.

BTM dominates the section by having more than 5000 restaurants.

In [ ]:
In [ ]:

geographical analysis

I need Latitudes & longitudes for each of the place for geaographical Data analysis,so to fetch lat,lon of each place,use Geopy

In [116]:
Out[116]:
(43690, 17)
In [117]:
Out[117]:
92
In [118]:
In [119]:
In [120]:
Out[120]:
Name new_Name
0 Banashankari Bangalore Banashankari
1 Basavanagudi Bangalore Basavanagudi
2 Mysore Road Bangalore Mysore Road
3 Jayanagar Bangalore Jayanagar
4 Kumaraswamy Layout Bangalore Kumaraswamy Layout
In [121]:
Collecting geopy
  Downloading geopy-2.2.0-py3-none-any.whl (118 kB)
Collecting geographiclib<2,>=1.49
  Downloading geographiclib-1.52-py3-none-any.whl (38 kB)
Installing collected packages: geographiclib, geopy
Successfully installed geographiclib-1.52 geopy-2.2.0
In [122]:
In [123]:
In [124]:
In [125]:
Out[125]:
Name new_Name geo_loc
0 Banashankari Bangalore Banashankari (15.8876779, 75.7046777)
1 Basavanagudi Bangalore Basavanagudi (12.9417261, 77.5755021)
2 Mysore Road Bangalore Mysore Road (12.3872141, 76.6669626)
3 Jayanagar Bangalore Jayanagar (27.64392675, 83.05280519687284)
4 Kumaraswamy Layout Bangalore Kumaraswamy Layout (12.9081487, 77.5553179)
In [126]:
We have found out latitude and longitude of each location listed in the dataset using geopy.
This is used to plot maps.
In [127]:
In [128]:
Out[128]:
Name count
0 BTM 4237
1 Koramangala 5th Block 2358
2 HSR 2113
3 Indiranagar 1892
4 JP Nagar 1849
now combine both the dataframes
In [129]:
Out[129]:
Name new_Name geo_loc
0 Banashankari Bangalore Banashankari (15.8876779, 75.7046777)
1 Basavanagudi Bangalore Basavanagudi (12.9417261, 77.5755021)
2 Mysore Road Bangalore Mysore Road (12.3872141, 76.6669626)
3 Jayanagar Bangalore Jayanagar (27.64392675, 83.05280519687284)
4 Kumaraswamy Layout Bangalore Kumaraswamy Layout (12.9081487, 77.5553179)
In [130]:
Out[130]:
(92, 3)
In [131]:
Out[131]:
(92, 2)
In [132]:
Out[132]:
Name count new_Name geo_loc
0 BTM 4237 Bangalore BTM (45.95485055, -112.49659530324134)
1 Koramangala 5th Block 2358 Bangalore Koramangala 5th Block (12.9343774, 77.628415)
2 HSR 2113 Bangalore HSR (18.1475, 41.538889)
3 Indiranagar 1892 Bangalore Indiranagar (12.9732913, 77.6404672)
4 JP Nagar 1849 Bangalore JP Nagar (12.2655944, 76.6465404)
In [133]:
Out[133]:
(91, 4)
In [134]:
Out[134]:
4237
In [135]:
Out[135]:
tuple
In [136]:
In [137]:
Out[137]:
91
In [138]:
Out[138]:
Name        0
count       0
new_Name    0
geo_loc     0
dtype: int64
In [139]:
Out[139]:
45.95485055
In [140]:
Out[140]:
-112.49659530324134
In [141]:
Out[141]:
array([(45.95485055, -112.49659530324134), (12.9343774, 77.628415),
       (18.1475, 41.538889), (12.9732913, 77.6404672),
       (12.2655944, 76.6465404), (27.64392675, 83.05280519687284),
       (44.3730577, -71.6118577), (12.9552572, 77.6984163),
       (12.9114375, 77.5999754), (12.9400321, 77.6203272),
       (12.9302645, 77.6332585), (44.621621, -84.790422),
       (12.93577245, 77.66676103753434), (14.5395813, 121.070371),
       (32.2934563, -64.78236307254568), (12.9252241, 77.6367015),
       (12.9778793, 77.6246697), (12.93433385, 77.63040639553275),
       (17.1452094, 79.6218777), (15.8876779, 75.7046777),
       (13.0221416, 77.6403368), (13.0027353, 77.5703253),
       (12.9417261, 77.5755021), (50.7721586, 0.09772783661369303),
       (-28.5477541, 29.788093), (33.5935063, -79.0345627),
       (12.996845, 77.6130165), (51.373656, -0.1042366),
       (13.0093455, 77.6377094), (13.0170347, 77.5726006),
       (40.7652844, -76.373824), (13.0141618, 77.6518539),
       (12.9882338, 77.554883), (31.89376, -88.066644),
       (12.9624669, 77.6381958), (17.5223139, 78.5804307),
       (23.769728, 90.3893881), (51.5230784, -0.7374421),
       (51.519619, -0.0744749), (12.945245, 77.6269144),
       (18.5322493, 73.8499601124847), (12.9678074, 77.6568367),
       (12.988721250000001, 77.58516877601824), (12.9417812, 77.6160146),
       (12.9489339, 77.5968273), (12.9271867, 77.6266252),
       (12.9081487, 77.5553179), (13.2227, 78.5541977),
       (12.9089453, 77.6239038), (12.973936, 77.6509982),
       (12.9931876, 77.5753419), (12.9932236, 77.5391579),
       (-34.0048654, 22.4414125), (52.7772638, 0.2966385),
       (13.0258087, 77.6305067), (1.2847055, 103.84320655721689),
       (13.02383, 77.5529215), (13.0358698, 77.6323597),
       (12.9243509, 77.6255562), (12.9414662, 77.7470942),
       (13.0646907, 77.49626895712257), (12.9846713, 77.6790908),
       (12.967576, 77.7150877), (39.76880625, -86.15345077251979),
       (12.7405867, 77.8200481), (23.1883478, 79.9092722),
       (17.2510682, 80.1651978), (13.0227204, 77.595715),
       (15.8782951, 74.5084834), (23.1485712, 81.6048241),
       (13.0621474, 77.58006135480495), (13.2923988, 77.7519261),
       (13.0215466, 77.7640586), (12.957998, 77.6037312),
       (38.7801076, -121.5056438), (12.945048, 77.263004),
       (13.6285774, 77.4642026), (13.0774728, 77.8010327),
       (12.5442176, 77.4213833), (12.3872141, 76.6669626),
       (13.0217151, 77.7660547), (13.007516, 77.695935),
       (13.0382184, 77.5919), (12.9055682, 77.5455438),
       (12.9176571, 77.4837568), (12.9900235, 77.572073),
       (12.8759384, 77.5960999), (13.1006982, 77.5963454),
       (12.9274413, 77.5155224), (12.9546741, 77.5121724),
       (13.0329419, 77.5273253)], dtype=object)
In [142]:
In [143]:
Out[143]:
tuple
In [144]:
In [145]:
Out[145]:
Name count new_Name geo_loc lat lon
0 BTM 4237 Bangalore BTM (45.95485055, -112.49659530324134) 45.954851 -112.496595
1 Koramangala 5th Block 2358 Bangalore Koramangala 5th Block (12.9343774, 77.628415) 12.934377 77.628415
2 HSR 2113 Bangalore HSR (18.1475, 41.538889) 18.147500 41.538889
3 Indiranagar 1892 Bangalore Indiranagar (12.9732913, 77.6404672) 12.973291 77.640467
4 JP Nagar 1849 Bangalore JP Nagar (12.2655944, 76.6465404) 12.265594 76.646540
In [146]:
Collecting folium
  Downloading folium-0.12.1-py2.py3-none-any.whl (94 kB)
Collecting branca>=0.3.0
  Downloading branca-0.4.2-py3-none-any.whl (24 kB)
Requirement already satisfied: jinja2>=2.9 in c:\users\cmraj\anaconda3\lib\site-packages (from folium) (2.11.3)
Requirement already satisfied: numpy in c:\users\cmraj\anaconda3\lib\site-packages (from folium) (1.20.1)
Requirement already satisfied: requests in c:\users\cmraj\anaconda3\lib\site-packages (from folium) (2.25.1)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\cmraj\anaconda3\lib\site-packages (from jinja2>=2.9->folium) (1.1.1)
Requirement already satisfied: chardet<5,>=3.0.2 in c:\users\cmraj\anaconda3\lib\site-packages (from requests->folium) (4.0.0)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\cmraj\anaconda3\lib\site-packages (from requests->folium) (1.26.4)
Requirement already satisfied: idna<3,>=2.5 in c:\users\cmraj\anaconda3\lib\site-packages (from requests->folium) (2.10)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\cmraj\anaconda3\lib\site-packages (from requests->folium) (2020.12.5)
Installing collected packages: branca, folium
Successfully installed branca-0.4.2 folium-0.12.1
In [147]:
In [148]:
Out[148]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [149]:
Out[149]:
[[45.95485055, -112.49659530324134, 4237.0],
 [12.9343774, 77.628415, 2358.0],
 [18.1475, 41.538889, 2113.0],
 [12.9732913, 77.6404672, 1892.0],
 [12.2655944, 76.6465404, 1849.0],
 [27.64392675, 83.05280519687284, 1711.0],
 [44.3730577, -71.6118577, 1688.0],
 [12.9552572, 77.6984163, 1488.0],
 [12.9114375, 77.5999754, 1318.0],
 [12.9400321, 77.6203272, 1103.0],
 [12.9302645, 77.6332585, 1084.0],
 [44.621621, -84.790422, 1084.0],
 [12.93577245, 77.66676103753434, 1078.0],
 [14.5395813, 121.070371, 964.0],
 [32.2934563, -64.78236307254568, 963.0],
 [12.9252241, 77.6367015, 913.0],
 [12.9778793, 77.6246697, 901.0],
 [12.93433385, 77.63040639553275, 864.0],
 [17.1452094, 79.6218777, 818.0],
 [15.8876779, 75.7046777, 805.0],
 [13.0221416, 77.6403368, 745.0],
 [13.0027353, 77.5703253, 657.0],
 [12.9417261, 77.5755021, 628.0],
 [50.7721586, 0.09772783661369303, 626.0],
 [-28.5477541, 29.788093, 607.0],
 [33.5935063, -79.0345627, 579.0],
 [12.996845, 77.6130165, 574.0],
 [51.373656, -0.1042366, 550.0],
 [13.0093455, 77.6377094, 522.0],
 [13.0170347, 77.5726006, 521.0],
 [40.7652844, -76.373824, 493.0],
 [13.0141618, 77.6518539, 491.0],
 [12.9882338, 77.554883, 487.0],
 [31.89376, -88.066644, 475.0],
 [12.9624669, 77.6381958, 426.0],
 [17.5223139, 78.5804307, 390.0],
 [23.769728, 90.3893881, 383.0],
 [51.5230784, -0.7374421, 343.0],
 [51.519619, -0.0744749, 309.0],
 [12.945245, 77.6269144, 292.0],
 [18.5322493, 73.8499601124847, 277.0],
 [12.9678074, 77.6568367, 262.0],
 [12.988721250000001, 77.58516877601824, 252.0],
 [12.9417812, 77.6160146, 227.0],
 [12.9489339, 77.5968273, 203.0],
 [12.9271867, 77.6266252, 193.0],
 [12.9081487, 77.5553179, 168.0],
 [13.2227, 78.5541977, 165.0],
 [12.9089453, 77.6239038, 157.0],
 [12.973936, 77.6509982, 152.0],
 [12.9931876, 77.5753419, 142.0],
 [12.9932236, 77.5391579, 141.0],
 [-34.0048654, 22.4414125, 140.0],
 [52.7772638, 0.2966385, 137.0],
 [13.0258087, 77.6305067, 129.0],
 [1.2847055, 103.84320655721689, 118.0],
 [13.02383, 77.5529215, 112.0],
 [13.0358698, 77.6323597, 111.0],
 [12.9243509, 77.6255562, 92.0],
 [12.9414662, 77.7470942, 91.0],
 [13.0646907, 77.49626895712257, 91.0],
 [12.9846713, 77.6790908, 91.0],
 [12.967576, 77.7150877, 84.0],
 [39.76880625, -86.15345077251979, 77.0],
 [12.7405867, 77.8200481, 74.0],
 [23.1883478, 79.9092722, 69.0],
 [17.2510682, 80.1651978, 66.0],
 [13.0227204, 77.595715, 63.0],
 [15.8782951, 74.5084834, 58.0],
 [23.1485712, 81.6048241, 50.0],
 [13.0621474, 77.58006135480495, 47.0],
 [13.2923988, 77.7519261, 31.0],
 [13.0215466, 77.7640586, 30.0],
 [12.957998, 77.6037312, 27.0],
 [38.7801076, -121.5056438, 26.0],
 [12.945048, 77.263004, 24.0],
 [13.6285774, 77.4642026, 23.0],
 [13.0774728, 77.8010327, 22.0],
 [12.5442176, 77.4213833, 19.0],
 [12.3872141, 76.6669626, 18.0],
 [13.0217151, 77.7660547, 14.0],
 [13.007516, 77.695935, 11.0],
 [13.0382184, 77.5919, 10.0],
 [12.9055682, 77.5455438, 9.0],
 [12.9176571, 77.4837568, 9.0],
 [12.9900235, 77.572073, 8.0],
 [12.8759384, 77.5960999, 5.0],
 [13.1006982, 77.5963454, 4.0],
 [12.9274413, 77.5155224, 2.0],
 [12.9546741, 77.5121724, 1.0],
 [13.0329419, 77.5273253, 1.0]]
In [150]:
Out[150]:
<folium.plugins.heat_map.HeatMap at 0x1f100eef7f0>
In [151]:
Out[151]:
Make this Notebook Trusted to load map: File -> Trust Notebook
It is clear that restaurants tend to concentrate in central bangalore area.
The clutter of restaurants lowers are we move away from central.
So,potential restaurant entrepreneurs can refer this and find out good locations for their venture.

note heatmap is good when we have latitude,longitude or imporatnce of that particular place or count of that place

Heatmap of North Indian restaurants

In [152]:
Out[152]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari
In [153]:
Out[153]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
5 https://www.zomato.com/bangalore/timepass-dinn... 37, 5-1, 4th Floor, Bosco Court, Gandhi Bazaar... Timepass Dinner Yes No 3.8 286 +91 9980040002\r\n+91 9980063005 Basavanagudi Casual Dining Onion Rings, Pasta, Kadhai Paneer, Salads, Sal... North Indian 600 [('Rated 3.0', 'RATED\n Food 3/5\nAmbience 3/... [] Buffet Banashankari
50 https://www.zomato.com/bangalore/petoo-banasha... 276, Ground Floor, 100 Feet Outer Ring Road, B... Petoo No No 3.7 21 +91 8026893211 Banashankari Quick Bites NaN North Indian 450 [('Rated 2.0', 'RATED\n This is a neatly made... [] Delivery Banashankari
72 https://www.zomato.com/bangalore/spicy-tandoor... Opposite ICICi Bank, Hanuman Nagar, Banashanka... Spicy Tandoor No No 0.0 0 +91 8050884222 Banashankari Quick Bites NaN North Indian 150 [('Rated 4.0', 'RATED\n cost for chicken roll... [] Delivery Banashankari
87 https://www.zomato.com/bangalore/krishna-sagar... 38, 22nd Main, 22nd Cross, Opposite BDA, 2nd S... Krishna Sagar No No 3.5 31 +91 8892752997\r\n+91 7204780429 Banashankari Quick Bites NaN North Indian 200 [('Rated 1.0', 'RATED\n Worst experience with... [] Delivery Banashankari
94 https://www.zomato.com/bangalore/nandhini-delu... 304, Opposite Apollo Public School, 100 Feet R... Nandhini Deluxe No No 2.6 283 080 26890011\r\n080 26890033 Banashankari Casual Dining Biryani, Chicken Guntur, Thali, Buttermilk, Ma... North Indian 600 [('Rated 3.0', 'RATED\n Ididnt like much.\n\n... [] Delivery Banashankari
In [154]:
Out[154]:
Name count
0 BTM 262
1 Banashankari 35
2 Banaswadi 9
3 Bannerghatta Road 60
4 Basavanagudi 17
In [155]:
In [156]:
Out[156]:
Name count new_Name geo_loc
0 BTM 262 Bangalore BTM (45.95485055, -112.49659530324134)
1 Banashankari 35 Bangalore Banashankari (15.8876779, 75.7046777)
2 Banaswadi 9 Bangalore Banaswadi (13.0141618, 77.6518539)
3 Bannerghatta Road 60 Bangalore Bannerghatta Road (12.9114375, 77.5999754)
4 Basavanagudi 17 Bangalore Basavanagudi (12.9417261, 77.5755021)
In [157]:
In [158]:
Out[158]:
Name count new_Name lan lon
0 BTM 262 Bangalore BTM 45.954851 -112.496595
1 Banashankari 35 Bangalore Banashankari 15.887678 75.704678
2 Banaswadi 9 Bangalore Banaswadi 13.014162 77.651854
3 Bannerghatta Road 60 Bangalore Bannerghatta Road 12.911437 77.599975
4 Basavanagudi 17 Bangalore Basavanagudi 12.941726 77.575502
... ... ... ... ... ...
58 Varthur Main Road, Whitefield 3 Bangalore Varthur Main Road, Whitefield 12.941466 77.747094
59 Vasanth Nagar 12 Bangalore Vasanth Nagar 12.988721 77.585169
60 Whitefield 146 Bangalore Whitefield 44.373058 -71.611858
61 Wilson Garden 37 Bangalore Wilson Garden 12.948934 77.596827
62 Yeshwantpur 3 Bangalore Yeshwantpur 13.023830 77.552921

63 rows × 5 columns

In [159]:
Out[159]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [ ]:
What about South Indian cuisines?
In [160]:
In [161]:
In [162]:
Out[162]:
Name count new_Name lan lon
0 BTM 262 Bangalore BTM 45.954851 -112.496595
1 Banashankari 35 Bangalore Banashankari 15.887678 75.704678
2 Banaswadi 9 Bangalore Banaswadi 13.014162 77.651854
3 Bannerghatta Road 60 Bangalore Bannerghatta Road 12.911437 77.599975
4 Basavanagudi 17 Bangalore Basavanagudi 12.941726 77.575502
In [163]:
Out[163]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [ ]:
In [164]:
In [165]:
Out[165]:
level_0 rest_type name count
0 0 Bakery Just Bake 44
1 0 Bakery Warm Oven 28
2 0 Bakery INDULGE by InnerChef 28
3 1 Bakery, Beverage Shop Homey Bake & Juice 1
4 1 Bakery, Beverage Shop Bake The Cake 1
... ... ... ... ...
203 85 Takeaway TheRiceBowl.In 8
204 85 Takeaway Mount View Fast Food 7
205 86 Takeaway, Delivery The Good Bowl 30
206 86 Takeaway, Delivery BOX8- Desi Meals 27
207 86 Takeaway, Delivery Juice Shop 19

208 rows × 4 columns

In [166]:
Out[166]:
url address online_order book_table rate votes phone location dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
rest_type name
Bakery 7th Heaven 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2
A Little For Love 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Adarsh Bakery 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2
Adi's Cake N Cafe 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2
Albert Bakery 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
Takeaway, Delivery Yumlane 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2
Yumme Veg 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2
Zamorin's Mappillah Biryani 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Zu's Doner Kebaps 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1
eat.fit 2 2 2 2 2 2 2 2 0 2 2 2 2 2 2

7712 rows × 15 columns

In [167]:
Out[167]:
url address online_order book_table rate votes phone location dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
rest_type name
Cafe Cafe Coffee Day 89 89 89 89 89 89 86 89 31 89 89 89 89 89 89
Casual Dining, Cafe Onesta 85 85 85 85 85 85 85 85 85 85 85 85 85 85 85
Quick Bites Five Star Chicken 67 67 67 67 67 67 62 67 10 67 67 67 67 67 67
Domino's Pizza 60 60 60 60 60 60 60 60 55 60 60 60 60 60 60
McDonald's 59 59 59 59 59 59 59 59 57 59 59 59 59 59 59
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
New Students Corner 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Dessert Parlor Mr Gola 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Casual Dining Parijatha Paradise 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Parijatha Fish Land 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Delivery SaJuSo 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1

7712 rows × 15 columns

In [168]:
Out[168]:
url address online_order book_table rate votes phone location dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
rest_type name
0 Bakery Just Bake 44 44 44 44 44 44 44 44 14 44 44 44 44 44 44
Warm Oven 28 28 28 28 28 28 28 28 7 28 28 28 28 28 28
INDULGE by InnerChef 28 28 28 28 28 28 28 28 0 28 28 28 28 28 28
Karachi Bakery 26 26 26 26 26 26 24 26 3 26 26 26 26 26 26
CakeZone 21 21 21 21 21 21 21 21 10 21 21 21 21 21 21
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
86 Takeaway, Delivery Agraharam Meal 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Adyar Ananda Bhavan Sweets 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Faasos 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
@North Parontha Hut 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1
Lucky Singh & Co 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

7712 rows × 15 columns

In [169]:
Out[169]:
    rest_type           name                      
0   Bakery              Just Bake                     44
                        Warm Oven                     28
                        INDULGE by InnerChef          28
                        Karachi Bakery                26
                        CakeZone                      21
                                                      ..
86  Takeaway, Delivery  Agraharam Meal                 1
                        Adyar Ananda Bhavan Sweets     1
                        Faasos                         1
                        @North Parontha Hut            1
                        Lucky Singh & Co               1
Name: url, Length: 7712, dtype: int64
In [170]:
Out[170]:
level_0 rest_type name url
0 0 Bakery Just Bake 44
1 0 Bakery Warm Oven 28
2 0 Bakery INDULGE by InnerChef 28
3 0 Bakery Karachi Bakery 26
4 0 Bakery CakeZone 21
... ... ... ... ...
7707 86 Takeaway, Delivery Agraharam Meal 1
7708 86 Takeaway, Delivery Adyar Ananda Bhavan Sweets 1
7709 86 Takeaway, Delivery Faasos 1
7710 86 Takeaway, Delivery @North Parontha Hut 1
7711 86 Takeaway, Delivery Lucky Singh & Co 1

7712 rows × 4 columns

In [171]:
In [172]:
Out[172]:
level_0 rest_type name count
0 0 Bakery Just Bake 44
1 0 Bakery Warm Oven 28
2 0 Bakery INDULGE by InnerChef 28
3 0 Bakery Karachi Bakery 26
4 0 Bakery CakeZone 21
... ... ... ... ...
7707 86 Takeaway, Delivery Agraharam Meal 1
7708 86 Takeaway, Delivery Adyar Ananda Bhavan Sweets 1
7709 86 Takeaway, Delivery Faasos 1
7710 86 Takeaway, Delivery @North Parontha Hut 1
7711 86 Takeaway, Delivery Lucky Singh & Co 1

7712 rows × 4 columns

In [173]:
Out[173]:
level_0 rest_type name count
1001 24 Casual Dining Empire Restaurant 58
1002 24 Casual Dining Beijing Bites 48
1003 24 Casual Dining Mani's Dum Biryani 47
1004 24 Casual Dining Chung Wah 46
1005 24 Casual Dining Oye Amritsar 41
... ... ... ... ...
2635 24 Casual Dining Uppercut - Sheraton Grand Bengaluru Whitefield... 1
2636 24 Casual Dining Utsav Restaurant 1
2637 24 Casual Dining VMS Star Biriyani 1
2638 24 Casual Dining Veruthe Oru Thattukada 1
2639 24 Casual Dining Parijatha Fish Land 1

1639 rows × 4 columns

In [174]:
Out[174]:
(43690, 17)

We can see tht Empire restaurant,Beijing bites and Mani's dum biriyani are the most popular casual dining restaurant chains in Bangalore. We will inspect them further...

Where are their outlets located?
In [ ]:
In [ ]:

Wordcloud of dishes liked by cuisines.

In [175]:
Collecting wordcloud
  Downloading wordcloud-1.8.1-cp38-cp38-win_amd64.whl (155 kB)
Requirement already satisfied: pillow in c:\users\cmraj\anaconda3\lib\site-packages (from wordcloud) (8.2.0)
Requirement already satisfied: numpy>=1.6.1 in c:\users\cmraj\anaconda3\lib\site-packages (from wordcloud) (1.20.1)
Requirement already satisfied: matplotlib in c:\users\cmraj\anaconda3\lib\site-packages (from wordcloud) (3.3.4)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in c:\users\cmraj\anaconda3\lib\site-packages (from matplotlib->wordcloud) (2.4.7)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\cmraj\anaconda3\lib\site-packages (from matplotlib->wordcloud) (1.3.1)
Requirement already satisfied: cycler>=0.10 in c:\users\cmraj\anaconda3\lib\site-packages (from matplotlib->wordcloud) (0.10.0)
Requirement already satisfied: python-dateutil>=2.1 in c:\users\cmraj\anaconda3\lib\site-packages (from matplotlib->wordcloud) (2.8.1)
Requirement already satisfied: six in c:\users\cmraj\anaconda3\lib\site-packages (from cycler>=0.10->matplotlib->wordcloud) (1.15.0)
Installing collected packages: wordcloud
Successfully installed wordcloud-1.8.1
In [176]:
In [177]:
Out[177]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city)
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari
In [178]:
In [179]:
Out[179]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city) update_dish_liked
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari [Pasta, Lunch Buffet, Masala Papad, Paneer ...
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari [Momos, Lunch Buffet, Chocolate Nirvana, Th...
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari [Churros, Cannelloni, Minestrone Soup, Hot ...
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari [Masala Dosa]
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari [Panipuri, Gol Gappe]
In [180]:
Out[180]:
Index(['Quick Bites', 'Casual Dining', 'Cafe', 'Dessert Parlor', 'Delivery',
       'Takeaway, Delivery', 'Casual Dining, Bar', 'Bakery', 'Beverage Shop'],
      dtype='object')
In [181]:
create wordcloud for each and every restaurant
In [182]:
In [183]:
Out[183]:
url                                0
address                            0
name                               0
online_order                       0
book_table                         0
rate                               0
votes                              0
phone                            591
location                           0
rest_type                        149
dish_liked                     20216
cuisines                           8
approx_cost(for two people)        0
reviews_list                       0
menu_item                          0
listed_in(type)                    0
listed_in(city)                    0
update_dish_liked                  0
dtype: int64
In [184]:
In [185]:
In [186]:
Out[186]:
url                              0
address                          0
name                             0
online_order                     0
book_table                       0
rate                             0
votes                            0
phone                          213
location                         0
rest_type                        0
dish_liked                       0
cuisines                         0
approx_cost(for two people)      0
reviews_list                     0
menu_item                        0
listed_in(type)                  0
listed_in(city)                  0
update_dish_liked                0
dtype: int64
wordcloud for 1 restaurant
In [187]:
In [188]:
Out[188]:
3                                              Masala Dosa
31       Burgers, Lassi, Chicken Grill, Naan, Momos, Ch...
34       Rolls, Veggie Wrap, Chocolate Fantasy, Rice Bo...
40       Dabeli, Faluda, Masala Poori, Sandwiches, Tokr...
42                           Burgers, Fries, Hot Chocolate
                               ...                        
51598                          Potato Fries, Chicken Curry
51601    Rolls, Chicken Tikka Roll, Chicken Bhuna Roll,...
51617                               Coffee, Vada, Mla Dosa
51629                             Fish, Veg Thali, Biryani
51645                                              Burgers
Name: dish_liked, Length: 5269, dtype: object
In [189]:
In [190]:
Out[190]:
(-0.5, 1499.5, 1499.5, -0.5)
In [ ]:
In [191]:
In [192]:
In [ ]:
analysing Reviews of Particular Restaurant
In [193]:
Out[193]:
url address name online_order book_table rate votes phone location rest_type dish_liked cuisines approx_cost(for two people) reviews_list menu_item listed_in(type) listed_in(city) update_dish_liked
0 https://www.zomato.com/bangalore/jalsa-banasha... 942, 21st Main Road, 2nd Stage, Banashankari, ... Jalsa Yes Yes 4.1 775 080 42297555\r\n+91 9743772233 Banashankari Casual Dining Pasta, Lunch Buffet, Masala Papad, Paneer Laja... North Indian, Mughlai, Chinese 800 [('Rated 4.0', 'RATED\n A beautiful place to ... [] Buffet Banashankari [Pasta, Lunch Buffet, Masala Papad, Paneer ...
1 https://www.zomato.com/bangalore/spice-elephan... 2nd Floor, 80 Feet Road, Near Big Bazaar, 6th ... Spice Elephant Yes No 4.1 787 080 41714161 Banashankari Casual Dining Momos, Lunch Buffet, Chocolate Nirvana, Thai G... Chinese, North Indian, Thai 800 [('Rated 4.0', 'RATED\n Had been here for din... [] Buffet Banashankari [Momos, Lunch Buffet, Chocolate Nirvana, Th...
2 https://www.zomato.com/SanchurroBangalore?cont... 1112, Next to KIMS Medical College, 17th Cross... San Churro Cafe Yes No 3.8 918 +91 9663487993 Banashankari Cafe, Casual Dining Churros, Cannelloni, Minestrone Soup, Hot Choc... Cafe, Mexican, Italian 800 [('Rated 3.0', "RATED\n Ambience is not that ... [] Buffet Banashankari [Churros, Cannelloni, Minestrone Soup, Hot ...
3 https://www.zomato.com/bangalore/addhuri-udupi... 1st Floor, Annakuteera, 3rd Stage, Banashankar... Addhuri Udupi Bhojana No No 3.7 88 +91 9620009302 Banashankari Quick Bites Masala Dosa South Indian, North Indian 300 [('Rated 4.0', "RATED\n Great food and proper... [] Buffet Banashankari [Masala Dosa]
4 https://www.zomato.com/bangalore/grand-village... 10, 3rd Floor, Lakshmi Associates, Gandhi Baza... Grand Village No No 3.8 166 +91 8026612447\r\n+91 9901210005 Basavanagudi Casual Dining Panipuri, Gol Gappe North Indian, Rajasthani 600 [('Rated 4.0', 'RATED\n Very good restaurant ... [] Buffet Banashankari [Panipuri, Gol Gappe]
In [194]:
Out[194]:
'[(\'Rated 4.0\', \'RATED\\n  A beautiful place to dine in.The interiors take you back to the Mughal era. The lightings are just perfect.We went there on the occasion of Christmas and so they had only limited items available. But the taste and service was not compromised at all.The only complaint is that the breads could have been better.Would surely like to come here again.\'), (\'Rated 4.0\', \'RATED\\n  I was here for dinner with my family on a weekday. The restaurant was completely empty. Ambience is good with some good old hindi music. Seating arrangement are good too. We ordered masala papad, panner and baby corn starters, lemon and corrionder soup, butter roti, olive and chilli paratha. Food was fresh and good, service is good too. Good for family hangout.\\nCheers\'), (\'Rated 2.0\', \'RATED\\n  Its a restaurant near to Banashankari BDA. Me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet. On inquiring they said this place is mostly visited by vegetarians. Anyways we ordered ala carte items which took ages to come. Food was ok ok. Definitely not visiting anymore.\'), (\'Rated 4.0\', \'RATED\\n  We went here on a weekend and one of us had the buffet while two of us took Ala Carte. Firstly the ambience and service of this place is great! The buffet had a lot of items and the good was good. We had a Pumpkin Halwa intm the dessert which was amazing. Must try! The kulchas are great here. Cheers!\'), (\'Rated 5.0\', \'RATED\\n  The best thing about the place is itÃ\x83\\x83Ã\x82\\x83Ã\x83\\x82Ã\x82\\x82Ã\x83\\x83Ã\x82\\x82Ã\x83\\x82Ã\x82\\x92s ambiance. Second best thing was yummy ? food. We try buffet and buffet food was not disappointed us.\\nTest ?. ?? ?? ?? ?? ??\\nQuality ?. ??????????.\\nService: Staff was very professional and friendly.\\n\\nOverall experience was excellent.\\n\\nsubirmajumder85.wixsite.com\'), (\'Rated 5.0\', \'RATED\\n  Great food and pleasant ambience. Expensive but Coll place to chill and relax......\\n\\nService is really very very good and friendly staff...\\n\\nFood : 5/5\\nService : 5/5\\nAmbience :5/5\\nOverall :5/5\'), (\'Rated 4.0\', \'RATED\\n  Good ambience with tasty food.\\nCheese chilli paratha with Bhutta palak methi curry is a good combo.\\nLemon Chicken in the starters is a must try item.\\nEgg fried rice was also quite tasty.\\nIn the mocktails, recommend "Alice in Junoon". Do not miss it.\'), (\'Rated 4.0\', \'RATED\\n  You canÃ\x83\\x83Ã\x82\\x83Ã\x83\\x82Ã\x82\\x82Ã\x83\\x83Ã\x82\\x82Ã\x83\\x82Ã\x82\\x92t go wrong with Jalsa. Never been a fan of their buffet and thus always order alacarteÃ\x83\\x83Ã\x82\\x83Ã\x83\\x82Ã\x82\\x82Ã\x83\\x83Ã\x82\\x82Ã\x83\\x82Ã\x82\\x92. Service at times can be on the slower side but food is worth the wait.\'), (\'Rated 5.0\', \'RATED\\n  Overdelighted by the service and food provided at this place. A royal and ethnic atmosphere builds a strong essence of being in India and also the quality and taste of food is truly authentic. I would totally recommend to visit this place once.\'), (\'Rated 4.0\', \'RATED\\n  The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome\'), (\'Rated 4.0\', \'RATED\\n  The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome\'), (\'Rated 4.0\', \'RATED\\n  The place is nice and comfortable. Food wise all jalea outlets maintain a good standard. The soya chaap was a standout dish. Clearly one of trademark dish as per me and a must try.\\n\\nThe only concern is the parking. It very congested and limited to just 5cars. The basement parking is very steep and makes it cumbersome\')]'
In [195]:
Out[195]:
'[(\'rated 4.0\', \'rated\\n  a beautiful place to dine in.the interiors take you back to the mughal era. the lightings are just perfect.we went there on the occasion of christmas and so they had only limited items available. but the taste and service was not compromised at all.the only complaint is that the breads could have been better.would surely like to come here again.\'), (\'rated 4.0\', \'rated\\n  i was here for dinner with my family on a weekday. the restaurant was completely empty. ambience is good with some good old hindi music. seating arrangement are good too. we ordered masala papad, panner and baby corn starters, lemon and corrionder soup, butter roti, olive and chilli paratha. food was fresh and good, service is good too. good for family hangout.\\ncheers\'), (\'rated 2.0\', \'rated\\n  its a restaurant near to banashankari bda. me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet. on inquiring they said this place is mostly visited by vegetarians. anyways we ordered ala carte items which took ages to come. food was ok ok. definitely not visiting anymore.\'), (\'rated 4.0\', \'rated\\n  we went here on a weekend and one of us had the buffet while two of us took ala carte. firstly the ambience and service of this place is great! the buffet had a lot of items and the good was good. we had a pumpkin halwa intm the dessert which was amazing. must try! the kulchas are great here. cheers!\'), (\'rated 5.0\', \'rated\\n  the best thing about the place is itã\x83\\x83ã\x82\\x83ã\x83\\x82ã\x82\\x82ã\x83\\x83ã\x82\\x82ã\x83\\x82ã\x82\\x92s ambiance. second best thing was yummy ? food. we try buffet and buffet food was not disappointed us.\\ntest ?. ?? ?? ?? ?? ??\\nquality ?. ??????????.\\nservice: staff was very professional and friendly.\\n\\noverall experience was excellent.\\n\\nsubirmajumder85.wixsite.com\'), (\'rated 5.0\', \'rated\\n  great food and pleasant ambience. expensive but coll place to chill and relax......\\n\\nservice is really very very good and friendly staff...\\n\\nfood : 5/5\\nservice : 5/5\\nambience :5/5\\noverall :5/5\'), (\'rated 4.0\', \'rated\\n  good ambience with tasty food.\\ncheese chilli paratha with bhutta palak methi curry is a good combo.\\nlemon chicken in the starters is a must try item.\\negg fried rice was also quite tasty.\\nin the mocktails, recommend "alice in junoon". do not miss it.\'), (\'rated 4.0\', \'rated\\n  you canã\x83\\x83ã\x82\\x83ã\x83\\x82ã\x82\\x82ã\x83\\x83ã\x82\\x82ã\x83\\x82ã\x82\\x92t go wrong with jalsa. never been a fan of their buffet and thus always order alacarteã\x83\\x83ã\x82\\x83ã\x83\\x82ã\x82\\x82ã\x83\\x83ã\x82\\x82ã\x83\\x82ã\x82\\x92. service at times can be on the slower side but food is worth the wait.\'), (\'rated 5.0\', \'rated\\n  overdelighted by the service and food provided at this place. a royal and ethnic atmosphere builds a strong essence of being in india and also the quality and taste of food is truly authentic. i would totally recommend to visit this place once.\'), (\'rated 4.0\', \'rated\\n  the place is nice and comfortable. food wise all jalea outlets maintain a good standard. the soya chaap was a standout dish. clearly one of trademark dish as per me and a must try.\\n\\nthe only concern is the parking. it very congested and limited to just 5cars. the basement parking is very steep and makes it cumbersome\'), (\'rated 4.0\', \'rated\\n  the place is nice and comfortable. food wise all jalea outlets maintain a good standard. the soya chaap was a standout dish. clearly one of trademark dish as per me and a must try.\\n\\nthe only concern is the parking. it very congested and limited to just 5cars. the basement parking is very steep and makes it cumbersome\'), (\'rated 4.0\', \'rated\\n  the place is nice and comfortable. food wise all jalea outlets maintain a good standard. the soya chaap was a standout dish. clearly one of trademark dish as per me and a must try.\\n\\nthe only concern is the parking. it very congested and limited to just 5cars. the basement parking is very steep and makes it cumbersome\')]'
In [196]:
Out[196]:
'   rated        rated n  a beautiful place to dine in the interiors take you back to the mughal era  the lightings are just perfect we went there on the occasion of christmas and so they had only limited items available  but the taste and service was not compromised at all the only complaint is that the breads could have been better would surely like to come here again       rated        rated n  i was here for dinner with my family on a weekday  the restaurant was completely empty  ambience is good with some good old hindi music  seating arrangement are good too  we ordered masala papad  panner and baby corn starters  lemon and corrionder soup  butter roti  olive and chilli paratha  food was fresh and good  service is good too  good for family hangout  ncheers      rated        rated n  its a restaurant near to banashankari bda  me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet  on inquiring they said this place is mostly visited by vegetarians  anyways we ordered ala carte items which took ages to come  food was ok ok  definitely not visiting anymore       rated        rated n  we went here on a weekend and one of us had the buffet while two of us took ala carte  firstly the ambience and service of this place is great  the buffet had a lot of items and the good was good  we had a pumpkin halwa intm the dessert which was amazing  must try  the kulchas are great here  cheers       rated        rated n  the best thing about the place is it   x     x     x     x     x     x     x     x  s ambiance  second best thing was yummy   food  we try buffet and buffet food was not disappointed us  ntest                   nquality                nservice  staff was very professional and friendly  n noverall experience was excellent  n nsubirmajumder   wixsite com      rated        rated n  great food and pleasant ambience  expensive but coll place to chill and relax       n nservice is really very very good and friendly staff    n nfood       nservice       nambience      noverall           rated        rated n  good ambience with tasty food  ncheese chilli paratha with bhutta palak methi curry is a good combo  nlemon chicken in the starters is a must try item  negg fried rice was also quite tasty  nin the mocktails  recommend  alice in junoon   do not miss it       rated        rated n  you can   x     x     x     x     x     x     x     x  t go wrong with jalsa  never been a fan of their buffet and thus always order alacarte   x     x     x     x     x     x     x     x    service at times can be on the slower side but food is worth the wait       rated        rated n  overdelighted by the service and food provided at this place  a royal and ethnic atmosphere builds a strong essence of being in india and also the quality and taste of food is truly authentic  i would totally recommend to visit this place once       rated        rated n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome      rated        rated n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome      rated        rated n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome   '
In [197]:
Out[197]:
'              n  a beautiful place to dine in the interiors take you back to the mughal era  the lightings are just perfect we went there on the occasion of christmas and so they had only limited items available  but the taste and service was not compromised at all the only complaint is that the breads could have been better would surely like to come here again                  n  i was here for dinner with my family on a weekday  the restaurant was completely empty  ambience is good with some good old hindi music  seating arrangement are good too  we ordered masala papad  panner and baby corn starters  lemon and corrionder soup  butter roti  olive and chilli paratha  food was fresh and good  service is good too  good for family hangout  ncheers                 n  its a restaurant near to banashankari bda  me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet  on inquiring they said this place is mostly visited by vegetarians  anyways we ordered ala carte items which took ages to come  food was ok ok  definitely not visiting anymore                  n  we went here on a weekend and one of us had the buffet while two of us took ala carte  firstly the ambience and service of this place is great  the buffet had a lot of items and the good was good  we had a pumpkin halwa intm the dessert which was amazing  must try  the kulchas are great here  cheers                  n  the best thing about the place is it   x     x     x     x     x     x     x     x  s ambiance  second best thing was yummy   food  we try buffet and buffet food was not disappointed us  ntest                   nquality                nservice  staff was very professional and friendly  n noverall experience was excellent  n nsubirmajumder   wixsite com                 n  great food and pleasant ambience  expensive but coll place to chill and relax       n nservice is really very very good and friendly staff    n nfood       nservice       nambience      noverall                      n  good ambience with tasty food  ncheese chilli paratha with bhutta palak methi curry is a good combo  nlemon chicken in the starters is a must try item  negg fried rice was also quite tasty  nin the mocktails  recommend  alice in junoon   do not miss it                  n  you can   x     x     x     x     x     x     x     x  t go wrong with jalsa  never been a fan of their buffet and thus always order alacarte   x     x     x     x     x     x     x     x    service at times can be on the slower side but food is worth the wait                  n  overdelighted by the service and food provided at this place  a royal and ethnic atmosphere builds a strong essence of being in india and also the quality and taste of food is truly authentic  i would totally recommend to visit this place once                  n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome                 n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome                 n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome   '
In [198]:
Out[198]:
'              n  a beautiful place to dine in the interiors take you back to the mughal era  the lightings are just perfect we went there on the occasion of christmas and so they had only limited items available  but the taste and service was not compromised at all the only complaint is that the breads could have been better would surely like to come here again                  n  i was here for dinner with my family on a weekday  the restaurant was completely empty  ambience is good with some good old hindi music  seating arrangement are good too  we ordered masala papad  panner and baby corn starters  lemon and corrionder soup  butter roti  olive and chilli paratha  food was fresh and good  service is good too  good for family hangout  ncheers                 n  its a restaurant near to banashankari bda  me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet  on inquiring they said this place is mostly visited by vegetarians  anyways we ordered ala carte items which took ages to come  food was ok ok  definitely not visiting anymore                  n  we went here on a weekend and one of us had the buffet while two of us took ala carte  firstly the ambience and service of this place is great  the buffet had a lot of items and the good was good  we had a pumpkin halwa intm the dessert which was amazing  must try  the kulchas are great here  cheers                  n  the best thing about the place is it                                                s ambiance  second best thing was yummy   food  we try buffet and buffet food was not disappointed us  ntest                   nquality                nservice  staff was very professional and friendly  n noverall e perience was e cellent  n nsubirmajumder   wi site com                 n  great food and pleasant ambience  e pensive but coll place to chill and rela        n nservice is really very very good and friendly staff    n nfood       nservice       nambience      noverall                      n  good ambience with tasty food  ncheese chilli paratha with bhutta palak methi curry is a good combo  nlemon chicken in the starters is a must try item  negg fried rice was also quite tasty  nin the mocktails  recommend  alice in junoon   do not miss it                  n  you can                                                t go wrong with jalsa  never been a fan of their buffet and thus always order alacarte                                                  service at times can be on the slower side but food is worth the wait                  n  overdelighted by the service and food provided at this place  a royal and ethnic atmosphere builds a strong essence of being in india and also the quality and taste of food is truly authentic  i would totally recommend to visit this place once                  n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome                 n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome                 n  the place is nice and comfortable  food wise all jalea outlets maintain a good standard  the soya chaap was a standout dish  clearly one of trademark dish as per me and a must try  n nthe only concern is the parking  it very congested and limited to just  cars  the basement parking is very steep and makes it cumbersome   '
remove multiple spaces
In [199]:
Out[199]:
' n a beautiful place to dine in the interiors take you back to the mughal era the lightings are just perfect we went there on the occasion of christmas and so they had only limited items available but the taste and service was not compromised at all the only complaint is that the breads could have been better would surely like to come here again n i was here for dinner with my family on a weekday the restaurant was completely empty ambience is good with some good old hindi music seating arrangement are good too we ordered masala papad panner and baby corn starters lemon and corrionder soup butter roti olive and chilli paratha food was fresh and good service is good too good for family hangout ncheers n its a restaurant near to banashankari bda me along with few of my office friends visited to have buffet but unfortunately they only provide veg buffet on inquiring they said this place is mostly visited by vegetarians anyways we ordered ala carte items which took ages to come food was ok ok definitely not visiting anymore n we went here on a weekend and one of us had the buffet while two of us took ala carte firstly the ambience and service of this place is great the buffet had a lot of items and the good was good we had a pumpkin halwa intm the dessert which was amazing must try the kulchas are great here cheers n the best thing about the place is it s ambiance second best thing was yummy food we try buffet and buffet food was not disappointed us ntest nquality nservice staff was very professional and friendly n noverall e perience was e cellent n nsubirmajumder wi site com n great food and pleasant ambience e pensive but coll place to chill and rela n nservice is really very very good and friendly staff n nfood nservice nambience noverall n good ambience with tasty food ncheese chilli paratha with bhutta palak methi curry is a good combo nlemon chicken in the starters is a must try item negg fried rice was also quite tasty nin the mocktails recommend alice in junoon do not miss it n you can t go wrong with jalsa never been a fan of their buffet and thus always order alacarte service at times can be on the slower side but food is worth the wait n overdelighted by the service and food provided at this place a royal and ethnic atmosphere builds a strong essence of being in india and also the quality and taste of food is truly authentic i would totally recommend to visit this place once n the place is nice and comfortable food wise all jalea outlets maintain a good standard the soya chaap was a standout dish clearly one of trademark dish as per me and a must try n nthe only concern is the parking it very congested and limited to just cars the basement parking is very steep and makes it cumbersome n the place is nice and comfortable food wise all jalea outlets maintain a good standard the soya chaap was a standout dish clearly one of trademark dish as per me and a must try n nthe only concern is the parking it very congested and limited to just cars the basement parking is very steep and makes it cumbersome n the place is nice and comfortable food wise all jalea outlets maintain a good standard the soya chaap was a standout dish clearly one of trademark dish as per me and a must try n nthe only concern is the parking it very congested and limited to just cars the basement parking is very steep and makes it cumbersome '

analyse review of a particular restaurant

In [200]:
In [201]:
Out[201]:
str
In [202]:
In [203]:
Out[203]:
(-0.5, 799.5, 799.5, -0.5)
In [204]:
In [205]:
In [ ]:
In [ ]: